package pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class WlOrderDetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WlOrderDetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCanrefundsIsNull() {
            addCriterion("canRefunds is null");
            return (Criteria) this;
        }

        public Criteria andCanrefundsIsNotNull() {
            addCriterion("canRefunds is not null");
            return (Criteria) this;
        }

        public Criteria andCanrefundsEqualTo(Integer value) {
            addCriterion("canRefunds =", value, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andCanrefundsNotEqualTo(Integer value) {
            addCriterion("canRefunds <>", value, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andCanrefundsGreaterThan(Integer value) {
            addCriterion("canRefunds >", value, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andCanrefundsGreaterThanOrEqualTo(Integer value) {
            addCriterion("canRefunds >=", value, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andCanrefundsLessThan(Integer value) {
            addCriterion("canRefunds <", value, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andCanrefundsLessThanOrEqualTo(Integer value) {
            addCriterion("canRefunds <=", value, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andCanrefundsIn(List<Integer> values) {
            addCriterion("canRefunds in", values, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andCanrefundsNotIn(List<Integer> values) {
            addCriterion("canRefunds not in", values, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andCanrefundsBetween(Integer value1, Integer value2) {
            addCriterion("canRefunds between", value1, value2, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andCanrefundsNotBetween(Integer value1, Integer value2) {
            addCriterion("canRefunds not between", value1, value2, "canrefunds");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNull() {
            addCriterion("orderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNotNull() {
            addCriterion("orderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernoEqualTo(String value) {
            addCriterion("orderNo =", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotEqualTo(String value) {
            addCriterion("orderNo <>", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThan(String value) {
            addCriterion("orderNo >", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
            addCriterion("orderNo >=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThan(String value) {
            addCriterion("orderNo <", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThanOrEqualTo(String value) {
            addCriterion("orderNo <=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLike(String value) {
            addCriterion("orderNo like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotLike(String value) {
            addCriterion("orderNo not like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIn(List<String> values) {
            addCriterion("orderNo in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotIn(List<String> values) {
            addCriterion("orderNo not in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoBetween(String value1, String value2) {
            addCriterion("orderNo between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotBetween(String value1, String value2) {
            addCriterion("orderNo not between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridIsNull() {
            addCriterion("groupBuyUserId is null");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridIsNotNull() {
            addCriterion("groupBuyUserId is not null");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridEqualTo(String value) {
            addCriterion("groupBuyUserId =", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridNotEqualTo(String value) {
            addCriterion("groupBuyUserId <>", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridGreaterThan(String value) {
            addCriterion("groupBuyUserId >", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridGreaterThanOrEqualTo(String value) {
            addCriterion("groupBuyUserId >=", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridLessThan(String value) {
            addCriterion("groupBuyUserId <", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridLessThanOrEqualTo(String value) {
            addCriterion("groupBuyUserId <=", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridLike(String value) {
            addCriterion("groupBuyUserId like", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridNotLike(String value) {
            addCriterion("groupBuyUserId not like", value, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridIn(List<String> values) {
            addCriterion("groupBuyUserId in", values, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridNotIn(List<String> values) {
            addCriterion("groupBuyUserId not in", values, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridBetween(String value1, String value2) {
            addCriterion("groupBuyUserId between", value1, value2, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andGroupbuyuseridNotBetween(String value1, String value2) {
            addCriterion("groupBuyUserId not between", value1, value2, "groupbuyuserid");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("userId is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("userId is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("userId =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("userId <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("userId >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("userId >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("userId <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("userId <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("userId like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("userId not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("userId in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("userId not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("userId between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("userId not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andCommodityidIsNull() {
            addCriterion("commodityId is null");
            return (Criteria) this;
        }

        public Criteria andCommodityidIsNotNull() {
            addCriterion("commodityId is not null");
            return (Criteria) this;
        }

        public Criteria andCommodityidEqualTo(String value) {
            addCriterion("commodityId =", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidNotEqualTo(String value) {
            addCriterion("commodityId <>", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidGreaterThan(String value) {
            addCriterion("commodityId >", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidGreaterThanOrEqualTo(String value) {
            addCriterion("commodityId >=", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidLessThan(String value) {
            addCriterion("commodityId <", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidLessThanOrEqualTo(String value) {
            addCriterion("commodityId <=", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidLike(String value) {
            addCriterion("commodityId like", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidNotLike(String value) {
            addCriterion("commodityId not like", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidIn(List<String> values) {
            addCriterion("commodityId in", values, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidNotIn(List<String> values) {
            addCriterion("commodityId not in", values, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidBetween(String value1, String value2) {
            addCriterion("commodityId between", value1, value2, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidNotBetween(String value1, String value2) {
            addCriterion("commodityId not between", value1, value2, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommoditynameIsNull() {
            addCriterion("commodityName is null");
            return (Criteria) this;
        }

        public Criteria andCommoditynameIsNotNull() {
            addCriterion("commodityName is not null");
            return (Criteria) this;
        }

        public Criteria andCommoditynameEqualTo(String value) {
            addCriterion("commodityName =", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameNotEqualTo(String value) {
            addCriterion("commodityName <>", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameGreaterThan(String value) {
            addCriterion("commodityName >", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameGreaterThanOrEqualTo(String value) {
            addCriterion("commodityName >=", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameLessThan(String value) {
            addCriterion("commodityName <", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameLessThanOrEqualTo(String value) {
            addCriterion("commodityName <=", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameLike(String value) {
            addCriterion("commodityName like", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameNotLike(String value) {
            addCriterion("commodityName not like", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameIn(List<String> values) {
            addCriterion("commodityName in", values, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameNotIn(List<String> values) {
            addCriterion("commodityName not in", values, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameBetween(String value1, String value2) {
            addCriterion("commodityName between", value1, value2, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameNotBetween(String value1, String value2) {
            addCriterion("commodityName not between", value1, value2, "commodityname");
            return (Criteria) this;
        }

        public Criteria andInventoryidIsNull() {
            addCriterion("inventoryId is null");
            return (Criteria) this;
        }

        public Criteria andInventoryidIsNotNull() {
            addCriterion("inventoryId is not null");
            return (Criteria) this;
        }

        public Criteria andInventoryidEqualTo(String value) {
            addCriterion("inventoryId =", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidNotEqualTo(String value) {
            addCriterion("inventoryId <>", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidGreaterThan(String value) {
            addCriterion("inventoryId >", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidGreaterThanOrEqualTo(String value) {
            addCriterion("inventoryId >=", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidLessThan(String value) {
            addCriterion("inventoryId <", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidLessThanOrEqualTo(String value) {
            addCriterion("inventoryId <=", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidLike(String value) {
            addCriterion("inventoryId like", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidNotLike(String value) {
            addCriterion("inventoryId not like", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidIn(List<String> values) {
            addCriterion("inventoryId in", values, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidNotIn(List<String> values) {
            addCriterion("inventoryId not in", values, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidBetween(String value1, String value2) {
            addCriterion("inventoryId between", value1, value2, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidNotBetween(String value1, String value2) {
            addCriterion("inventoryId not between", value1, value2, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andPropertyIsNull() {
            addCriterion("property is null");
            return (Criteria) this;
        }

        public Criteria andPropertyIsNotNull() {
            addCriterion("property is not null");
            return (Criteria) this;
        }

        public Criteria andPropertyEqualTo(String value) {
            addCriterion("property =", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotEqualTo(String value) {
            addCriterion("property <>", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyGreaterThan(String value) {
            addCriterion("property >", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyGreaterThanOrEqualTo(String value) {
            addCriterion("property >=", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyLessThan(String value) {
            addCriterion("property <", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyLessThanOrEqualTo(String value) {
            addCriterion("property <=", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyLike(String value) {
            addCriterion("property like", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotLike(String value) {
            addCriterion("property not like", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyIn(List<String> values) {
            addCriterion("property in", values, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotIn(List<String> values) {
            addCriterion("property not in", values, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyBetween(String value1, String value2) {
            addCriterion("property between", value1, value2, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotBetween(String value1, String value2) {
            addCriterion("property not between", value1, value2, "property");
            return (Criteria) this;
        }

        public Criteria andImageIsNull() {
            addCriterion("image is null");
            return (Criteria) this;
        }

        public Criteria andImageIsNotNull() {
            addCriterion("image is not null");
            return (Criteria) this;
        }

        public Criteria andImageEqualTo(String value) {
            addCriterion("image =", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotEqualTo(String value) {
            addCriterion("image <>", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThan(String value) {
            addCriterion("image >", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanOrEqualTo(String value) {
            addCriterion("image >=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThan(String value) {
            addCriterion("image <", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThanOrEqualTo(String value) {
            addCriterion("image <=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLike(String value) {
            addCriterion("image like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotLike(String value) {
            addCriterion("image not like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageIn(List<String> values) {
            addCriterion("image in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotIn(List<String> values) {
            addCriterion("image not in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageBetween(String value1, String value2) {
            addCriterion("image between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotBetween(String value1, String value2) {
            addCriterion("image not between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(Integer value) {
            addCriterion("price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(Integer value) {
            addCriterion("price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(Integer value) {
            addCriterion("price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(Integer value) {
            addCriterion("price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(Integer value) {
            addCriterion("price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<Integer> values) {
            addCriterion("price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<Integer> values) {
            addCriterion("price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(Integer value1, Integer value2) {
            addCriterion("price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(Integer value1, Integer value2) {
            addCriterion("price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNull() {
            addCriterion("quantity is null");
            return (Criteria) this;
        }

        public Criteria andQuantityIsNotNull() {
            addCriterion("quantity is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityEqualTo(Integer value) {
            addCriterion("quantity =", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotEqualTo(Integer value) {
            addCriterion("quantity <>", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThan(Integer value) {
            addCriterion("quantity >", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity >=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThan(Integer value) {
            addCriterion("quantity <", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityLessThanOrEqualTo(Integer value) {
            addCriterion("quantity <=", value, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityIn(List<Integer> values) {
            addCriterion("quantity in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotIn(List<Integer> values) {
            addCriterion("quantity not in", values, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityBetween(Integer value1, Integer value2) {
            addCriterion("quantity between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andQuantityNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity not between", value1, value2, "quantity");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNull() {
            addCriterion("money is null");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNotNull() {
            addCriterion("money is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyEqualTo(Integer value) {
            addCriterion("money =", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotEqualTo(Integer value) {
            addCriterion("money <>", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThan(Integer value) {
            addCriterion("money >", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("money >=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThan(Integer value) {
            addCriterion("money <", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThanOrEqualTo(Integer value) {
            addCriterion("money <=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyIn(List<Integer> values) {
            addCriterion("money in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotIn(List<Integer> values) {
            addCriterion("money not in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyBetween(Integer value1, Integer value2) {
            addCriterion("money between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("money not between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyIsNull() {
            addCriterion("discountMoney is null");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyIsNotNull() {
            addCriterion("discountMoney is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyEqualTo(Integer value) {
            addCriterion("discountMoney =", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyNotEqualTo(Integer value) {
            addCriterion("discountMoney <>", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyGreaterThan(Integer value) {
            addCriterion("discountMoney >", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountMoney >=", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyLessThan(Integer value) {
            addCriterion("discountMoney <", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyLessThanOrEqualTo(Integer value) {
            addCriterion("discountMoney <=", value, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyIn(List<Integer> values) {
            addCriterion("discountMoney in", values, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyNotIn(List<Integer> values) {
            addCriterion("discountMoney not in", values, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyBetween(Integer value1, Integer value2) {
            addCriterion("discountMoney between", value1, value2, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("discountMoney not between", value1, value2, "discountmoney");
            return (Criteria) this;
        }

        public Criteria andUseintegralIsNull() {
            addCriterion("useIntegral is null");
            return (Criteria) this;
        }

        public Criteria andUseintegralIsNotNull() {
            addCriterion("useIntegral is not null");
            return (Criteria) this;
        }

        public Criteria andUseintegralEqualTo(Integer value) {
            addCriterion("useIntegral =", value, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUseintegralNotEqualTo(Integer value) {
            addCriterion("useIntegral <>", value, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUseintegralGreaterThan(Integer value) {
            addCriterion("useIntegral >", value, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUseintegralGreaterThanOrEqualTo(Integer value) {
            addCriterion("useIntegral >=", value, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUseintegralLessThan(Integer value) {
            addCriterion("useIntegral <", value, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUseintegralLessThanOrEqualTo(Integer value) {
            addCriterion("useIntegral <=", value, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUseintegralIn(List<Integer> values) {
            addCriterion("useIntegral in", values, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUseintegralNotIn(List<Integer> values) {
            addCriterion("useIntegral not in", values, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUseintegralBetween(Integer value1, Integer value2) {
            addCriterion("useIntegral between", value1, value2, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUseintegralNotBetween(Integer value1, Integer value2) {
            addCriterion("useIntegral not between", value1, value2, "useintegral");
            return (Criteria) this;
        }

        public Criteria andUsebalanceIsNull() {
            addCriterion("useBalance is null");
            return (Criteria) this;
        }

        public Criteria andUsebalanceIsNotNull() {
            addCriterion("useBalance is not null");
            return (Criteria) this;
        }

        public Criteria andUsebalanceEqualTo(Integer value) {
            addCriterion("useBalance =", value, "usebalance");
            return (Criteria) this;
        }

        public Criteria andUsebalanceNotEqualTo(Integer value) {
            addCriterion("useBalance <>", value, "usebalance");
            return (Criteria) this;
        }

        public Criteria andUsebalanceGreaterThan(Integer value) {
            addCriterion("useBalance >", value, "usebalance");
            return (Criteria) this;
        }

        public Criteria andUsebalanceGreaterThanOrEqualTo(Integer value) {
            addCriterion("useBalance >=", value, "usebalance");
            return (Criteria) this;
        }

        public Criteria andUsebalanceLessThan(Integer value) {
            addCriterion("useBalance <", value, "usebalance");
            return (Criteria) this;
        }

        public Criteria andUsebalanceLessThanOrEqualTo(Integer value) {
            addCriterion("useBalance <=", value, "usebalance");
            return (Criteria) this;
        }

        public Criteria andUsebalanceIn(List<Integer> values) {
            addCriterion("useBalance in", values, "usebalance");
            return (Criteria) this;
        }

        public Criteria andUsebalanceNotIn(List<Integer> values) {
            addCriterion("useBalance not in", values, "usebalance");
            return (Criteria) this;
        }

        public Criteria andUsebalanceBetween(Integer value1, Integer value2) {
            addCriterion("useBalance between", value1, value2, "usebalance");
            return (Criteria) this;
        }

        public Criteria andUsebalanceNotBetween(Integer value1, Integer value2) {
            addCriterion("useBalance not between", value1, value2, "usebalance");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("updateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("updateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("updateTime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("updateTime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("updateTime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updateTime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("updateTime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("updateTime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("updateTime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("updateTime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("updateTime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("updateTime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCommentIsNull() {
            addCriterion("comment is null");
            return (Criteria) this;
        }

        public Criteria andCommentIsNotNull() {
            addCriterion("comment is not null");
            return (Criteria) this;
        }

        public Criteria andCommentEqualTo(Integer value) {
            addCriterion("comment =", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotEqualTo(Integer value) {
            addCriterion("comment <>", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThan(Integer value) {
            addCriterion("comment >", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThanOrEqualTo(Integer value) {
            addCriterion("comment >=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThan(Integer value) {
            addCriterion("comment <", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThanOrEqualTo(Integer value) {
            addCriterion("comment <=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentIn(List<Integer> values) {
            addCriterion("comment in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotIn(List<Integer> values) {
            addCriterion("comment not in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentBetween(Integer value1, Integer value2) {
            addCriterion("comment between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotBetween(Integer value1, Integer value2) {
            addCriterion("comment not between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andProxyidsIsNull() {
            addCriterion("proxyIds is null");
            return (Criteria) this;
        }

        public Criteria andProxyidsIsNotNull() {
            addCriterion("proxyIds is not null");
            return (Criteria) this;
        }

        public Criteria andProxyidsEqualTo(String value) {
            addCriterion("proxyIds =", value, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsNotEqualTo(String value) {
            addCriterion("proxyIds <>", value, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsGreaterThan(String value) {
            addCriterion("proxyIds >", value, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsGreaterThanOrEqualTo(String value) {
            addCriterion("proxyIds >=", value, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsLessThan(String value) {
            addCriterion("proxyIds <", value, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsLessThanOrEqualTo(String value) {
            addCriterion("proxyIds <=", value, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsLike(String value) {
            addCriterion("proxyIds like", value, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsNotLike(String value) {
            addCriterion("proxyIds not like", value, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsIn(List<String> values) {
            addCriterion("proxyIds in", values, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsNotIn(List<String> values) {
            addCriterion("proxyIds not in", values, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsBetween(String value1, String value2) {
            addCriterion("proxyIds between", value1, value2, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxyidsNotBetween(String value1, String value2) {
            addCriterion("proxyIds not between", value1, value2, "proxyids");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityIsNull() {
            addCriterion("proxyCommodityQuantity is null");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityIsNotNull() {
            addCriterion("proxyCommodityQuantity is not null");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityEqualTo(String value) {
            addCriterion("proxyCommodityQuantity =", value, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityNotEqualTo(String value) {
            addCriterion("proxyCommodityQuantity <>", value, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityGreaterThan(String value) {
            addCriterion("proxyCommodityQuantity >", value, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityGreaterThanOrEqualTo(String value) {
            addCriterion("proxyCommodityQuantity >=", value, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityLessThan(String value) {
            addCriterion("proxyCommodityQuantity <", value, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityLessThanOrEqualTo(String value) {
            addCriterion("proxyCommodityQuantity <=", value, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityLike(String value) {
            addCriterion("proxyCommodityQuantity like", value, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityNotLike(String value) {
            addCriterion("proxyCommodityQuantity not like", value, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityIn(List<String> values) {
            addCriterion("proxyCommodityQuantity in", values, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityNotIn(List<String> values) {
            addCriterion("proxyCommodityQuantity not in", values, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityBetween(String value1, String value2) {
            addCriterion("proxyCommodityQuantity between", value1, value2, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommodityquantityNotBetween(String value1, String value2) {
            addCriterion("proxyCommodityQuantity not between", value1, value2, "proxycommodityquantity");
            return (Criteria) this;
        }

        public Criteria andProxycommissionIsNull() {
            addCriterion("proxyCommission is null");
            return (Criteria) this;
        }

        public Criteria andProxycommissionIsNotNull() {
            addCriterion("proxyCommission is not null");
            return (Criteria) this;
        }

        public Criteria andProxycommissionEqualTo(Integer value) {
            addCriterion("proxyCommission =", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionNotEqualTo(Integer value) {
            addCriterion("proxyCommission <>", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionGreaterThan(Integer value) {
            addCriterion("proxyCommission >", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionGreaterThanOrEqualTo(Integer value) {
            addCriterion("proxyCommission >=", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionLessThan(Integer value) {
            addCriterion("proxyCommission <", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionLessThanOrEqualTo(Integer value) {
            addCriterion("proxyCommission <=", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionIn(List<Integer> values) {
            addCriterion("proxyCommission in", values, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionNotIn(List<Integer> values) {
            addCriterion("proxyCommission not in", values, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionBetween(Integer value1, Integer value2) {
            addCriterion("proxyCommission between", value1, value2, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionNotBetween(Integer value1, Integer value2) {
            addCriterion("proxyCommission not between", value1, value2, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andShareidIsNull() {
            addCriterion("shareId is null");
            return (Criteria) this;
        }

        public Criteria andShareidIsNotNull() {
            addCriterion("shareId is not null");
            return (Criteria) this;
        }

        public Criteria andShareidEqualTo(String value) {
            addCriterion("shareId =", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidNotEqualTo(String value) {
            addCriterion("shareId <>", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidGreaterThan(String value) {
            addCriterion("shareId >", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidGreaterThanOrEqualTo(String value) {
            addCriterion("shareId >=", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidLessThan(String value) {
            addCriterion("shareId <", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidLessThanOrEqualTo(String value) {
            addCriterion("shareId <=", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidLike(String value) {
            addCriterion("shareId like", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidNotLike(String value) {
            addCriterion("shareId not like", value, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidIn(List<String> values) {
            addCriterion("shareId in", values, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidNotIn(List<String> values) {
            addCriterion("shareId not in", values, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidBetween(String value1, String value2) {
            addCriterion("shareId between", value1, value2, "shareid");
            return (Criteria) this;
        }

        public Criteria andShareidNotBetween(String value1, String value2) {
            addCriterion("shareId not between", value1, value2, "shareid");
            return (Criteria) this;
        }

        public Criteria andSharecommissionIsNull() {
            addCriterion("shareCommission is null");
            return (Criteria) this;
        }

        public Criteria andSharecommissionIsNotNull() {
            addCriterion("shareCommission is not null");
            return (Criteria) this;
        }

        public Criteria andSharecommissionEqualTo(Integer value) {
            addCriterion("shareCommission =", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionNotEqualTo(Integer value) {
            addCriterion("shareCommission <>", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionGreaterThan(Integer value) {
            addCriterion("shareCommission >", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionGreaterThanOrEqualTo(Integer value) {
            addCriterion("shareCommission >=", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionLessThan(Integer value) {
            addCriterion("shareCommission <", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionLessThanOrEqualTo(Integer value) {
            addCriterion("shareCommission <=", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionIn(List<Integer> values) {
            addCriterion("shareCommission in", values, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionNotIn(List<Integer> values) {
            addCriterion("shareCommission not in", values, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionBetween(Integer value1, Integer value2) {
            addCriterion("shareCommission between", value1, value2, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionNotBetween(Integer value1, Integer value2) {
            addCriterion("shareCommission not between", value1, value2, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andMastermoneyIsNull() {
            addCriterion("masterMoney is null");
            return (Criteria) this;
        }

        public Criteria andMastermoneyIsNotNull() {
            addCriterion("masterMoney is not null");
            return (Criteria) this;
        }

        public Criteria andMastermoneyEqualTo(Integer value) {
            addCriterion("masterMoney =", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyNotEqualTo(Integer value) {
            addCriterion("masterMoney <>", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyGreaterThan(Integer value) {
            addCriterion("masterMoney >", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("masterMoney >=", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyLessThan(Integer value) {
            addCriterion("masterMoney <", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyLessThanOrEqualTo(Integer value) {
            addCriterion("masterMoney <=", value, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyIn(List<Integer> values) {
            addCriterion("masterMoney in", values, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyNotIn(List<Integer> values) {
            addCriterion("masterMoney not in", values, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyBetween(Integer value1, Integer value2) {
            addCriterion("masterMoney between", value1, value2, "mastermoney");
            return (Criteria) this;
        }

        public Criteria andMastermoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("masterMoney not between", value1, value2, "mastermoney");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}